| Section |
Description |
| Aggregates |
Aggregate Columns provide a mechanism for analyzing data in summary form across one or more tables. This section gives an overview of aggregate creation in Engine. |
| CBAT |
The underlying technology for Engine is Column Based Analytical Technology (CBAT). This section looks at what CBAT means and the implications of using this approach to data analysis. |
| Crosstabs |
Most database systems are able to evaluate statistical functions, produce frequency distributions and execute Group By queries. Engine supports this functionality via its NSQL Query language. It also offers a powerful alternative via its Crosstabulation Engine. The section introduces the Crosstab object. |
| Data Types |
This section introduces the basic data types that are available within Engine |
| Domains and Recordsets |
Rather than use a Recordset to store and view selection details, Engine uses a Domain. This section describes domains and the implications of using domains for data analysis. |
| Expressions |
Expression fields are derived data created using the Built-In functions provided with Engine. This section introduces Expression fields and looks at some of the common uses of expression based derived data. |
| Externalization |
Externalization refers to the process whereby certain intensive Engine activities are off loaded to one or more remote machines with the aim of improving performance and load time. These activities inlcude Indexing, Link Building and Crosstab processing, all of which are cross-compilable as both 32 bit and 64 bit. |
| Links |
Engine is different to a standard RDBMS system in how it creates and uses links. This section looks at the differences and discusses the implications of using Engine's approach to link creation. |
| Loading Data |
One of the main features of Engine is the speed with which it loads data. This section gives an overview of how data is loaded, stored and indexed into the system. |
| Multi-tenancy |
Multi-Tenancy allows multiple instances of Engine to run on the same Engine server. This means that an Engine server will run multiple NucEngine.exe processes. This features allows partners to host multiple appropriate sized client databases on the same server with no security implications. |
| Queries |
Like any standard RDBMS system, Engine allows queries to be executed in order to obtain selection results and summarized data. This section gives an overview of query execution using Engine. |
| Remaps |
A Remap is a data field whose values are directly dependent on the values of another field in the system. This section looks at the type of Remaps that can be created using Engine and discusses some of the uses of remapped data. |
| Resolution Levels |
All analysis results from Engine are relative to a table. This table is referred to as the Resolution Level of the analytic operation. This section discusses how Resolution Levels are determined and how the resolution level affects the results that are obtained. |
| Schema |
This section introduces the basic data objects in Engine and describes how the data is organized on disk. |
